//package Experiment;
/**
 * 目前没有用处
 */
//import javax.servlet.ServletException;
//import javax.servlet.http.HttpServlet;
//import javax.servlet.http.HttpServletRequest;
//import javax.servlet.http.HttpServletResponse;
//import java.io.IOException;
//import java.io.PrintWriter;
//import java.sql.Connection;
//import java.sql.DriverManager;
//import java.sql.ResultSet;
//import java.sql.Statement;
//
//public class showCar extends HttpServlet {
//    @Override
//    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//        doPost(req, resp);
//    }
//
//    @Override
//    protected void doHead(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//        //设置服务器端以UTF-8编码进行输出
//        resp.setCharacterEncoding("UTF-8");
//        //设置浏览器以UTF-8编码进行接收,解决中文乱码问题
//        resp.setContentType("text/html;charset=UTF-8");
//        PrintWriter out = resp.getWriter();
//        try {
//            try {
//                System.out.println("here");
//                String url = "jdbc:sqlserver://localhost:1433;DataBaseName=Login;integratedSecurity=true;";
//                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//                Connection comm = DriverManager.getConnection(url);
//                //String sql = "INSERT into Book (bookNo) VALUES ('"+Num+"')";
//                String sql = "select * from Book";
//                System.out.println("a");
//                Statement st = comm.createStatement();
//                ResultSet rs = st.executeQuery(sql);
//                while(rs.next()){
////                    System.out.println(rs.getString(1)+""+rs.getString(2));
//                    out.println(rs.getString(1)+""+rs.getString(2));
//                }
//                //5 执行sql语句
//                int temp =st.executeUpdate(sql);
//                System.out.println("返回的值："+temp);
//                rs.close();
//                //6 关闭sql对象
//                st.close();
//                //7 关闭连接
//                comm.close();
//
//                resp.setHeader("refresh","3,http://localhost:8080/javaWeb_war_exploded/market.jsp");
//                System.out.println("b");
//            } catch (ClassNotFoundException e) {
//                e.printStackTrace();
//            }
//        } catch (Exception e) {
//            e.printStackTrace();
//        }
//    }
//}
